Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_RSRC_PLANS

`DBA_RSRC_PLANS` displays information about all resource plans in the database. For a list of currently active plans, see "V$RSRC_PLAN".

Column | Datatype | NULL | Description
--- | --- | --- | ---
`PLAN` | `VARCHAR2(30)` |  | Name of the resource plan
`NUM_PLAN_DIRECTIVES` | `NUMBER` |  | Number of plan directives for the plan
`CPU_METHOD` | `VARCHAR2(30)` |  | CPU resource allocation method for the plan
`ACTIVE_SESS_POOL_MTH` | `VARCHAR2(30)` |  | Active session pool resource allocation method for the plan
`PARALLEL_DEGREE_LIMIT_MTH` | `VARCHAR2(30)` |  | Parallel degree limit resource allocation method for the plan
`QUEUING_MTH` | `VARCHAR2(30)` |  | Queuing resource allocation method for the plan
`COMMENTS` | `VARCHAR2(2000)` |  | Text comment on the plan
`STATUS` | `VARCHAR2(30)` |  | `PENDING`. if plan is part of the pending area; `NULL` otherwise.
`MANDATORY` | `VARCHAR2(3)` |  | Indicates whether the plan is mandatory (`YES`) or not (`NO`)

See Also: Oracle Database Administrator's Guide for information on resource plans in general Oracle Database PL/SQL Packages and Types Reference for more information on creating resource plans with the `DBMS_RESOURCE_MANAGER` package